package org.skywork.top.core.algorithm.sql;

/**
 * 上升的温度
 */
public class no_197 {

    public void sql() {
        String sql = "select w2.id from Weather w1, Weather w2 where w2.temperature > w1.temperature and w2.recordDate = DATE_ADD(w1.recordDate, INTERVAL 1 DAY)";
        System.out.println(sql);
    }

}
